NTISthis.com

Evidence Guide: ICTPRG554 - Manage data persistence using noSQL data stores

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICTPRG554 - Manage data persistence using noSQL data stores

What evidence can you provide to prove your understanding of each of the following citeria?

Review and select noSQL options

  1. Confirm use and application for noSQL according to business requirements and needs
  2. Research and compare horizontal and vertical scaling and confirm relevance and benefit of horizontal scaling according to business requirements
  3. Research and compare noSQL technologies and traditional relational data models
  4. Research, review and select noSQL vendor technologies according to business requirements
Confirm use and application for noSQL according to business requirements and needs

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Research and compare horizontal and vertical scaling and confirm relevance and benefit of horizontal scaling according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Research and compare noSQL technologies and traditional relational data models

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Research, review and select noSQL vendor technologies according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine and create storage of data types

  1. Design and determine data storage requirements from noSQL data store according to selected vendor technology and business requirements
  2. Review and select required types of noSQL data store according to business requirements
  3. Create partition key and determine storage place of data items
  4. Review and determine required partition key and ensure effective distribution of storage across partition
Design and determine data storage requirements from noSQL data store according to selected vendor technology and business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review and select required types of noSQL data store according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Create partition key and determine storage place of data items

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review and determine required partition key and ensure effective distribution of storage across partition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Build and configure indexes

  1. Determine and select required sort key according to business requirements
  2. Calculate, determine and configure read and write through-puts according to business requirements
  3. Determine, configure and create indexes for optimising data retrieval queries
  4. Determine and create additional indexes
  5. Optimise data queries and retrievals for indexes according to business requirements
  6. Determine and configure time-to-live (TTL) on data objects according to business requirements
Determine and select required sort key according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Calculate, determine and configure read and write through-puts according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine, configure and create indexes for optimising data retrieval queries

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine and create additional indexes

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Optimise data queries and retrievals for indexes according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Determine and configure time-to-live (TTL) on data objects according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use queries and retrieve objects

  1. Research and select required API client for interacting with noSQL data store according to business requirements
  2. Substantiate and connect API client to noSQL data store instance
  3. Insert single data object into noSQL datastore using selected client application
  4. Insert multiple items in single operation
  5. Use query and select single object
  6. Use query and retrieve multiple objects in batch
  7. Perform query against index
  8. Perform query to select required attributes and project results
Research and select required API client for interacting with noSQL data store according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Substantiate and connect API client to noSQL data store instance

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Insert single data object into noSQL datastore using selected client application

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Insert multiple items in single operation

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use query and select single object

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use query and retrieve multiple objects in batch

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform query against index

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform query to select required attributes and project results

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Confirm interaction of objects

  1. Delete single and multiple objects according to business requirements
  2. Update single and multiple objects according to business requirements
  3. Persist objects with different data types
  4. Configure and confirm change event triggers and notifications according to business needs
  5. Test, fix and ensure responses and trigger notifications work according to business requirements
  6. Review and confirm data is encrypted and authorisation and authentications are active according to user and client access requirements
  7. Test and fix data persistence process according to business requirements
  8. Document and finalise work according to business requirements
Delete single and multiple objects according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Update single and multiple objects according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Persist objects with different data types

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Configure and confirm change event triggers and notifications according to business needs

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test, fix and ensure responses and trigger notifications work according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Review and confirm data is encrypted and authorisation and authentications are active according to user and client access requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Test and fix data persistence process according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document and finalise work according to business requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Required Skills and Knowledge

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

create at least three different queries, including updating, deleting and creating data types

create at least two indexes.

In the course of the above, the candidate must:

specify partition and sort keys

optimise the data.

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

benefits and functions of noSQL database and schema free data persistence, as well as traditional relational data models

methods and different features and functions between scaling out and scaling up (horizontal and vertical)

language used in required programming language for noSQL applications

partitioning in a noSQL environment and its related terms

functions and features for time-to-live (TTL) requirements

authorisation and authentications procedures and levels of responsibility according to client access requirements

distribution of data storage across partitions

debugging and testing methodologies and techniques

functions and features of sort keys in noSQL storage

features of transport encryptions, authentication and authorisation

different noSQL data store formats, including:

key value

document based

column based

graph based

different noSQL data types, including:

numeric

string

boolean

complex

date time.